Delphi Magazine Collection 2001/Delphi Magazine Collection 20001 (2001).iso/DISKS/Issue66/SQLComp/InterBaseDemo/UFmMain.dfm/UFmMain.txt

Text File | 2000-10-11 | 5.2 KB | 256 lines

object FmMain: TFmMain
  Left = 40
  Top = 62
  Width = 729
  Height = 500
  Caption = 'SQL Components Demo (IBX version)'
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  PixelsPerInch = 96
  TextHeight = 13
  object Label1: TLabel
    Left = 8
    Top = 8
    Width = 103
    Height = 13
    Caption = 'Full name (containing)'
  end
  object Label2: TLabel
    Left = 8
    Top = 56
    Width = 72
    Height = 13
    Caption = 'Hire date (from)'
  end
  object Label3: TLabel
    Left = 8
    Top = 152
    Width = 41
    Height = 13
    Caption = 'Emp. No'
  end
  object Label4: TLabel
    Left = 104
    Top = 56
    Width = 61
    Height = 13
    Caption = 'Hire date (to)'
  end
  object Label5: TLabel
    Left = 8
    Top = 104
    Width = 58
    Height = 13
    Caption = 'Salary (from)'
  end
  object Label6: TLabel
    Left = 104
    Top = 104
    Width = 47
    Height = 13
    Caption = 'Salary (to)'
  end
  object Label7: TLabel
    Left = 72
    Top = 152
    Width = 43
    Height = 13
    Caption = 'Dept. No'
  end
  object Bevel1: TBevel
    Left = 320
    Top = 8
    Width = 9
    Height = 217
    Shape = bsLeftLine
  end
  object Label8: TLabel
    Left = 200
    Top = 8
    Width = 45
    Height = 13
    Caption = 'Job Code'
  end
  object EtFullName: TDMSQLEdit
    Left = 8
    Top = 24
    Width = 185
    Height = 21
    TabOrder = 0
    Criterion.DataSource = DsResult
    Criterion.DataField = 'FULL_NAME'
    Criterion.SQLOperator = opContaining
  end
  object EtHireDateFrom: TDMSQLEdit
    Left = 8
    Top = 72
    Width = 89
    Height = 21
    TabOrder = 1
    Criterion.DataSource = DsResult
    Criterion.DataField = 'HIRE_DATE'
    Criterion.DataType = ftDateTime
    Criterion.SQLOperator = opGreaterThanOrEqualTo
  end
  object PbBuildSQL: TButton
    Left = 8
    Top = 200
    Width = 65
    Height = 25
    Caption = 'Refresh'
    TabOrder = 7
    OnClick = PbBuildSQLClick
  end
  object EtEmpNo: TDMSQLEdit
    Left = 8
    Top = 168
    Width = 57
    Height = 21
    TabOrder = 5
    Criterion.DataSource = DsResult
    Criterion.DataField = 'EMP_NO'
    Criterion.DataType = ftInteger
  end
  object GdResult: TDBGrid
    Left = 8
    Top = 232
    Width = 705
    Height = 233
    Anchors = [akLeft, akTop, akRight, akBottom]
    DataSource = DsResult
    TabOrder = 10
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
  end
  object EtHireDateTo: TDMSQLEdit
    Left = 104
    Top = 72
    Width = 89
    Height = 21
    TabOrder = 2
    Criterion.DataSource = DsResult
    Criterion.DataField = 'HIRE_DATE'
    Criterion.DataType = ftDateTime
    Criterion.SQLOperator = opLessThanOrEqualTo
  end
  object EtSQL: TMemo
    Left = 328
    Top = 8
    Width = 385
    Height = 217
    Anchors = [akLeft, akTop, akRight]
    Font.Charset = ANSI_CHARSET
    Font.Color = clWindowText
    Font.Height = -11
    Font.Name = 'Courier New'
    Font.Style = []
    ParentColor = True
    ParentFont = False
    ReadOnly = True
    ScrollBars = ssBoth
    TabOrder = 9
  end
  object PbClear: TButton
    Left = 80
    Top = 200
    Width = 49
    Height = 25
    Caption = 'Clear'
    TabOrder = 8
    OnClick = PbClearClick
  end
  object EtSalaryFrom: TDMSQLEdit
    Left = 8
    Top = 120
    Width = 89
    Height = 21
    TabOrder = 3
    Criterion.DataSource = DsResult
    Criterion.DataField = 'SALARY'
    Criterion.DataType = ftCurrency
    Criterion.SQLOperator = opGreaterThanOrEqualTo
  end
  object EtSalaryTo: TDMSQLEdit
    Left = 104
    Top = 120
    Width = 89
    Height = 21
    TabOrder = 4
    Criterion.DataSource = DsResult
    Criterion.DataField = 'SALARY'
    Criterion.DataType = ftCurrency
    Criterion.SQLOperator = opLessThanOrEqualTo
  end
  object EtDeptNo: TDMSQLEdit
    Left = 72
    Top = 168
    Width = 57
    Height = 21
    TabOrder = 6
    Criterion.DataSource = DsResult
    Criterion.DataField = 'DEPT_NO'
    Criterion.DataType = ftInteger
  end
  object LbJobCode: TDMSQLListBox
    Left = 200
    Top = 24
    Width = 113
    Height = 201
    ItemHeight = 13
    Items.Strings = (
      'VP'
      'Eng'
      'Mktg'
      'Mngr'
      'SRep')
    MultiSelect = True
    TabOrder = 11
    Criterion.DataSource = DsResult
    Criterion.DataField = 'JOB_CODE'
  end
  object DsResult: TDataSource
    DataSet = QyResult
    Left = 344
    Top = 240
  end
  object QyResult: TDMSQLIBQuery
    Database = DB
    Transaction = Trans
    BufferChunks = 1000
    CachedUpdates = False
    SQL.Strings = (
      'select * from employee')
    Implementor.SQLOptions = [sqlOpenAfterBuild]
    Left = 256
    Top = 240
  end
  object DB: TIBDatabase
    Connected = True
    DatabaseName = 'C:\Programmi\Borland\InterBase\examples\Database\employee.gdb'
    Params.Strings = (
      'user_name=SYSDBA'
      'password=masterkey')
    LoginPrompt = False
    DefaultTransaction = Trans
    IdleTimer = 0
    SQLDialect = 1
    TraceFlags = []
    Left = 448
    Top = 240
  end
  object Trans: TIBTransaction
    Active = False
    DefaultDatabase = DB
    Left = 552
    Top = 240
  end
end